SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511169 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511169 [ RunTime:0.003187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413375,460591,482470,508741,623897,292098,28972,1024683,997178,441388,132512,922015,399332,381235,173402,618263,291634,46998,897105,605845,1048512,623303,706058,277797,675235,502019,553341,390164,286691,639569,972433,460077,836848,69233,425823,983956,930067,549817,705229,180721,954993,754790,216361,987581,891322,538479,66088,842754,839894,878137,294301,169426,497642,197838,401712,126922,51356,4017,252978,924978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]