SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040631 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040631 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898982,982754,707438,74203,158453,1048888,520394,748486,479096,47203,352027,821177,376845,733154,723737,211858,652363,331282,38412,998175,177348,421035,717656,733174,912973,800532,257086,238820,455821,812930,837321,909690,22654,227448,704261,527981,1026832,710121,356081,112247,288394,129972,62698,742034,893273,907364,499902,2714,198355,530213,637458,134611,83047,389205,510807,82677,582305,750097,172180,613809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]