SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341334 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341334 [ RunTime:0.003976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868166,127148,1024756,1008149,196095,55882,986754,203266,778708,400723,436521,268560,267049,786969,82110,1942,514134,751196,720801,212286,452501,189827,451422,128938,175153,932632,587700,728081,302747,99041,951563,409578,801315,539654,218037,242397,147185,490577,386267,761955,213368,853296,504486,143999,554256,288688,1001989,554812,627402,520791,124512,840679,139486,249481,676560,968384,308743,981611,470598,434453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]