SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104025 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104025 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309924,397440,283195,550313,110434,19766,513926,1030104,850009,1047029,562533,937281,661714,579087,841433,325137,956256,916325,407328,272253,540616,570377,384922,197539,660815,65441,831158,634078,30534,473368,107093,222936,166321,822652,742902,539458,955566,497833,287631,301150,276459,510875,896689,364598,360398,929076,83650,393656,310795,969282,130829,469819,329687,821038,178819,773868,833080,22140,75192,453724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]