SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423211 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423211 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811925,722261,868093,26416,831683,652705,610118,549306,436274,109072,305711,928500,787734,726279,136417,356301,339332,968533,985852,810072,973428,636374,733960,885155,109186,166010,14874,353022,517918,340274,488422,864830,93103,521952,86128,337697,609838,1048328,68666,766207,494152,730167,751,550345,1043899,392169,692376,938866,353190,373705,286973,783295,252160,704788,2999,614981,379593,36952,545427,768405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]