SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560857 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560857 [ RunTime:0.006992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451475,986413,476702,622189,684906,947803,277446,742501,885203,315803,692895,397687,941250,131873,652896,36809,220709,713620,767584,389004,626528,199007,232051,257424,161486,877641,876501,449323,568560,669057,744217,564241,684070,160558,451203,936837,181643,929397,739070,579048,999215,33744,1000633,548776,81397,235244,1045671,825743,203834,399266,277972,774210,301865,46286,432111,441718,39781,413050,75657,911311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]