SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531412 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531412 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280464,233365,158942,461417,782806,271121,861101,847106,832266,485247,538360,490026,412145,84631,440389,845067,793428,407477,205794,566050,800054,44447,490900,581326,438443,328595,347978,695536,552728,737692,706388,732857,664369,914242,815530,463700,30605,952923,530317,799111,932712,525769,841331,1032723,880172,586765,786852,847665,230871,438713,843158,328068,737263,506226,377749,462525,340302,825366,949349,508217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]