SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310514 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310514 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342436,619866,942407,160229,1017815,207134,241399,761714,234862,491048,892458,182297,32297,619012,452470,570944,925096,64499,674801,445256,378946,148744,430693,117029,727240,947180,235787,763946,279347,440911,762391,108640,221515,337406,678836,797024,588879,342304,295257,266116,947823,673984,140787,416176,326043,419160,490863,45926,737111,133522,878029,549290,779,260746,958934,17092,652875,788265,948701,280825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]