SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300164 LIMIT 1 [ RunTime:0.002489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300164 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746116,920443,23698,888545,110709,900165,416540,383656,928221,403633,300515,1015301,622874,931475,768627,277743,60833,489370,594380,218048,514271,133958,116327,972018,434216,481890,1023083,443836,512760,279070,860509,190240,433747,392326,984195,714476,773838,444226,457885,202320,349170,1036971,681531,153795,187892,458503,108033,117793,738649,627328,704029,157488,549889,806129,387250,812690,291780,718084,312501,106057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]