SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522649 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522649 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457964,397726,459495,274624,256548,84096,201902,46219,124579,855369,73263,836508,450453,333525,70252,342459,119266,793208,400610,246078,1040013,436467,492719,609418,167054,343374,765558,716667,738437,8923,543192,121094,259853,767680,300080,551207,99768,253898,465412,344684,430345,831322,711691,381105,412692,447084,849231,431761,622728,849632,636140,828043,176820,849064,385696,544743,737949,133897,613500,840102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003317s ]