SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34158 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34158 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450874,136406,944299,607544,764739,253269,699914,235267,771387,885984,350834,493485,697624,310729,737789,713525,5766,176649,981863,424185,218557,165618,739296,519943,213727,272671,12685,402847,120219,545805,834335,667551,341334,799356,489407,784203,639048,904713,40387,654579,273949,132806,189411,852073,101258,618610,424743,478191,699003,753358,369449,354684,888388,484304,633486,910793,98053,18382,994194,841590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]