SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514731 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514731 [ RunTime:0.004526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380810,622835,145403,128626,331612,1003864,708715,257153,855880,31394,335828,815026,650392,319001,401097,180651,28249,238786,979943,376328,44804,194964,412549,594682,645012,798239,789067,17351,773057,546559,392611,358914,569233,1003048,121844,54387,206790,514013,901819,250245,1048021,261951,411884,654357,979342,17982,680055,270798,56161,434014,641023,344305,901514,728991,460098,157675,1007904,58440,890455,324240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]