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` = 638018 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 638018 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432128,748844,686039,122902,153882,949281,441533,750062,782195,821844,337662,353860,1045358,590130,157806,386515,105737,175724,905720,808582,309083,869402,702511,316929,139723,371663,569969,525575,135104,482000,61415,1910,149199,782653,510253,210529,68669,862076,320579,428129,360992,315129,789006,310434,254666,156772,251941,780612,590633,360314,259196,943381,1029068,408023,237480,821927,901594,266692,597812,35525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 638018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 638018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]