SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457884 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457884 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945806,844790,669919,649818,886380,194740,358384,874999,112868,643631,1011145,164302,894900,883344,541749,580550,1018679,101932,547094,186094,29906,357008,422265,1025357,980672,1220,568647,229031,816262,658464,847376,363844,234147,193777,244358,364681,320210,118391,859322,846625,703574,318126,821267,664361,970465,622575,526736,502623,112142,594481,150739,254613,3744,849840,804916,759256,625831,20070,117244,920401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]