SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448746 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448746 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493941,678812,333229,771742,450866,841963,500614,566425,854161,473090,485304,828786,691433,91344,5804,863520,667560,847590,323909,777397,471573,124420,507754,999771,975109,604135,416691,435562,338274,854527,985413,752056,188354,989036,903847,598015,714690,246138,984591,293324,129279,135556,187277,406409,314107,588968,788540,115724,322900,319135,599369,202122,661938,946203,644714,650100,964182,564733,425419,54654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]