SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305003 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305003 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462525,728044,1014227,965899,729076,441384,455949,597081,590262,511618,322806,629129,109665,216897,217283,57205,329934,634666,273069,1029940,334717,699976,284766,949686,852128,578862,442550,887354,379190,605741,236907,946849,899963,239339,408043,667397,161249,990318,428598,204473,898039,51649,879905,148322,175958,239639,406094,280778,559099,496124,67440,340936,993551,75604,928556,780570,378044,241833,326517,331094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]