SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019460 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019460 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223003,860029,617124,209898,821541,331330,914722,340175,979105,606479,184572,237379,692128,520523,793733,453816,933844,512010,853312,115695,846317,671858,345662,93002,160611,649459,333502,239532,205424,718957,758025,113400,146436,305034,440261,1024884,767267,461683,255196,693863,420118,404828,544730,901268,939731,264381,732000,612776,503611,80040,521746,376167,1045589,101836,9187,223435,625350,607829,57748,371658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002219s ]