SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320517 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320517 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953388,293949,753838,340803,1003249,302700,787406,680408,724873,295105,1044272,705056,14224,70505,622770,954465,954299,338466,91545,411365,231463,451729,152569,868866,612696,435626,85446,102075,32701,139247,1043342,535865,736484,270645,897594,630660,167515,577505,35489,15768,604417,859658,921204,79328,204450,24906,781819,977787,544937,130822,757191,374744,946380,299355,169457,835054,486719,663140,280815,686359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]