SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 37320 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 37320 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584601,552390,648220,1046936,614976,243620,312135,452223,145204,253729,90122,6494,1024866,783467,580974,998961,374257,987589,539386,781024,362845,130492,568627,526096,708010,530870,887805,919966,885766,844557,640754,1034214,595092,820212,638945,526172,642280,325764,849996,425344,355004,891251,198996,874331,993194,300251,524508,20373,552340,310419,661210,774706,828018,488483,780704,734528,651227,622431,942377,24845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 37320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 37320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]