SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036040 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036040 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239680,987393,842393,457214,952773,408006,986646,394798,598806,480801,675006,600772,996357,258104,511997,515684,1032493,401319,970798,853284,108165,201607,50397,555780,69748,978807,967641,177870,592499,961792,418,939713,802557,982574,184653,445557,904554,432382,544579,288965,660172,741100,744742,691991,749372,397740,314888,653554,561449,774896,222297,156284,830654,921766,78304,476019,370482,925576,146739,946659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001712s ]