SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158708 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158708 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987505,714775,1047158,150750,378902,124799,489421,170516,701973,599691,246196,69980,467485,961233,516673,765778,98703,799917,371011,79700,167908,1021130,530402,157273,1026567,203813,78001,394800,1033209,590271,781541,535754,757109,191375,342128,889180,111023,485281,642867,137187,646426,307275,43027,903081,318989,37455,448762,886623,11442,426183,143598,863362,734651,717588,240430,874126,169206,524297,320284,465383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]