SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42913 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42913 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001439,413283,392440,907751,18147,733633,866425,79029,620517,166722,702924,54341,515934,202600,128305,658676,627010,813016,673034,164343,1027659,970930,487943,501784,115180,286903,690620,331196,256119,898995,789139,238634,942727,938658,144746,851792,92894,86086,403933,370577,678944,2588,215927,908778,914215,18099,1024150,100556,699370,957948,407966,403724,90165,664007,674492,907069,29285,236788,281513,915406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]