SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480965 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480965 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599982,629791,174995,681746,170543,506721,432294,210527,507834,462909,210492,978837,736187,663147,534613,710155,673381,967941,22742,128302,1042560,1006527,299487,434343,686800,117038,61980,430197,992360,734420,971884,392405,912211,101819,940452,948345,225173,387899,69210,818245,835969,975070,236989,261962,965610,886447,152984,281096,976347,887449,88879,9945,456262,842448,248196,59339,125531,840758,797364,7470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]