SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420826 LIMIT 1 [ RunTime:0.001336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420826 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210348,564000,497066,591701,192888,376666,351746,370320,47261,703317,513741,886690,497361,165094,481048,557153,979948,81689,981025,197296,720044,394096,718197,95737,665843,654035,294626,105133,900047,920976,284536,954398,531713,842072,797157,961024,770167,5477,299915,833811,489697,748711,157823,5199,351861,598016,540627,815359,154739,940495,485940,476033,306391,245987,425183,431295,314035,966032,77800,1032065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]