SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014064 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014064 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545331,827391,189700,311893,615714,989260,456704,641423,838245,777778,557326,528155,714402,226203,531834,1044567,101526,417102,176388,499873,423328,713370,244311,840783,19251,922540,468763,339738,608790,219671,571615,294945,294057,715881,709440,424768,145776,23266,398636,965506,372597,758169,168299,770891,190195,416697,279094,230372,324368,924295,732852,375728,288607,565189,285248,163786,803511,458784,183859,897763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]