SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314608 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314608 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301314,417010,140302,420522,664673,1002307,876262,994081,332933,1041467,787224,512954,329389,853215,94210,585752,142071,127803,780288,212150,724123,161930,531525,47617,218465,419645,902268,562885,740282,25420,342894,530110,657487,908955,319113,422227,250625,766867,505833,303832,232134,248578,781220,7679,488551,662846,807858,84763,56335,628263,206186,907498,933391,191228,669943,34678,104292,407790,427911,715311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]