SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80653 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80653 [ RunTime:0.003008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029440,591420,972781,344821,677517,345001,606176,453765,919454,105455,1034697,440583,1011486,818225,1027137,742375,621967,633985,342499,860902,313353,329747,156751,470497,1015428,648595,415544,151076,377849,829194,586366,920302,623107,701573,730948,1026620,56757,183997,740200,850483,300343,741681,212115,313532,148051,426036,532309,803546,950230,565435,539222,947582,496221,912750,319509,29636,703402,468681,135942,43273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]