SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596639 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596639 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622333,1045880,648921,688018,122361,363526,57523,656254,80646,656133,974073,487758,106577,549462,152174,911062,303511,535223,680098,768817,444357,291306,113701,386070,854155,54785,543214,844490,1004384,927009,800830,256022,746225,519997,398649,631957,339040,327780,490247,601637,898286,940954,876269,92687,588949,945690,365818,586255,117367,463186,747435,308234,1030603,58578,880394,986807,91084,83836,234536,181563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]