SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402241 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402241 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617482,29266,820341,478481,899129,234856,999822,542329,428182,826642,196093,413735,970983,249813,953417,180130,554483,472882,488882,878009,656446,888681,629912,584255,1045664,359786,238105,389505,806597,696285,696558,545166,683391,386375,256732,462312,462291,600604,498396,672775,916727,179047,147393,903790,817656,1010073,464363,92118,174771,802542,750097,937973,230454,1012080,291235,39070,1032986,44296,876294,586111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]