SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 228144 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 228144 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335712,1038004,916856,941978,722150,791719,550897,913827,60004,526548,386154,744491,445706,1025771,776370,1004520,223438,176041,161112,20283,974528,222068,426782,525113,929577,888821,33855,692892,752890,699426,844048,229931,52718,906631,602300,510701,219317,668239,183604,635785,941226,621476,37157,689471,361831,260398,22846,1028085,391600,221567,618822,942238,734796,908025,2567,730750,3699,425318,747296,207743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 228144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 228144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]