SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801035 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801035 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004454,891735,383767,269076,876639,43600,509040,429702,257438,782700,998624,923485,403873,910070,796207,450760,557370,728040,104984,287072,394597,388129,675883,437300,31476,136000,303427,87767,613911,176318,191835,60666,8140,25922,267619,811054,721836,405387,280586,48661,573359,1007667,20798,607718,892669,304476,894623,813025,60384,431133,692091,980428,288160,960111,911754,270018,634687,953442,848160,438183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]