SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448103 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448103 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84348,751349,205376,970057,877409,1031031,160510,672780,1034880,660127,643823,241014,392008,385400,899904,1003886,671763,4435,707409,1046256,733519,1046540,572043,586258,609960,605505,303087,139394,815266,851486,925969,984203,575332,147785,667717,525922,533340,427124,954297,296784,277521,531494,663969,997100,725288,700024,577410,63260,514942,788228,770182,514948,889746,824830,741041,201576,353397,834401,520422,530134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]