SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103108 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103108 [ RunTime:0.006494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108806,435243,626664,77886,611924,983750,934803,242486,401061,59715,722476,845931,410602,1037438,87580,89313,280290,336222,478090,654404,1032106,723933,805544,941884,125170,66763,395983,646717,348090,813016,109011,33840,913169,150196,824588,114000,1043194,1035736,592103,634602,562547,749547,789281,342824,265212,632169,253679,1041736,1010420,733025,192552,684632,804832,300553,704781,1034956,795262,784307,848534,1044205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]