SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40012 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40012 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364082,672117,511186,948493,570285,139756,1003921,937198,621764,927978,175633,787360,191843,180340,898009,217072,554275,182672,309606,356247,796399,663988,604179,373859,266886,658386,983780,31820,699997,745979,99301,292006,282589,267748,13055,871989,862908,720723,81230,56495,993781,359635,353368,10480,10474,191950,636969,786885,771,432593,89078,205837,648341,451470,1002136,932010,7824,263578,973872,1008894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]