SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311940 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311940 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9834,656104,67014,130283,407638,506509,45420,699554,280788,694247,833618,994926,696226,322665,599581,714873,778966,186929,558738,298024,68092,1018249,827287,890067,731300,912693,952915,708666,388405,231637,919448,478594,560181,182879,127796,119126,1024583,735853,296163,605822,92241,987711,51315,594751,679343,664516,845379,98013,841856,671177,571583,361141,153821,290653,485269,856972,785005,343865,488690,983260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]