SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69800 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69800 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213049,94667,445115,375199,521913,802476,985476,984360,677810,1032069,92985,193,177541,271783,46754,518688,296762,74646,352871,1018657,131022,720589,422010,62174,843582,919909,35250,696120,600657,1011791,28132,989281,239491,759269,824587,962816,711531,977735,239397,1026545,151479,985257,521138,571420,436154,200244,585873,974592,980034,709909,58704,770944,887631,869193,265337,1012831,274030,251970,671890,800727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]