SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040146 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040146 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574918,40788,810959,95191,667601,185320,1045231,467867,763906,191409,75737,629635,61719,563207,747470,197068,481574,623185,844473,951407,158472,712800,456694,1034373,304073,167001,872969,309292,451977,375489,818506,455935,58346,793575,53645,660770,445785,1027058,157002,365237,230955,999970,281769,701242,900816,635169,355004,247561,273997,575414,701596,288050,594446,660676,570881,249001,825882,691704,255178,1011466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]