SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 163913 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 163913 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783683,272358,501289,392211,363667,967218,911091,265114,987806,871764,274670,252146,845248,20724,927307,998732,901486,555808,829151,29120,869912,223408,723018,28048,1039601,577043,375368,7976,840037,431876,473230,155938,404025,510246,885073,1026309,1000221,649440,345211,333229,328535,956440,517826,760881,39297,201748,771950,100172,171793,450735,771058,697379,921672,951876,79500,638756,189543,734271,740672,810495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 163913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 163913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]