SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314023 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314023 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923185,360221,97525,881658,671981,290162,900554,945532,333356,779002,1047410,564099,213816,78342,585964,721990,858122,845213,890265,50055,408032,159204,247077,429628,459382,576344,688361,115427,852146,335040,509785,440966,390987,414287,589153,130902,879379,271411,998062,629081,895506,159170,591366,501293,400948,755851,611647,116125,865664,1039885,333633,323975,18997,189427,278173,453160,916434,924980,414784,270068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]