SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543211 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543211 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117098,31908,924384,202058,679567,432270,662213,207834,916173,573402,1004829,444782,375674,600523,311643,278748,603902,945713,904350,106335,787192,767409,361334,5806,256662,249781,433881,412796,853971,13899,165421,513150,144462,795401,104247,851034,86467,614854,219580,696717,105088,928106,99514,122753,397266,871817,239085,494615,657210,650950,977635,793551,298823,318099,581600,376247,952860,582738,522744,105523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]