SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34980 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34980 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604253,104898,624065,719120,36487,1001935,346436,399376,646267,156134,557745,269080,814604,1009187,1002651,437335,996695,741657,121734,831389,585104,599315,813430,513585,712549,201904,431186,587503,150540,441935,671953,9448,917939,1035169,229419,340232,115931,205630,496614,655521,920794,105647,239699,672349,971121,1020437,165600,62688,622177,143868,550369,1007074,872307,676547,794761,206411,734179,260755,635044,226645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]