SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040801 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040801 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618237,888709,651744,145941,334858,1010933,285284,672016,195314,117896,200192,728718,131866,678498,33873,989963,30851,20306,264075,769106,542329,470207,1018803,177466,544185,78016,721260,1006252,716743,663079,549351,255338,869470,669862,234216,61245,793300,90928,1036340,525350,813433,249505,819211,595731,108998,665095,705794,880133,887663,595713,681053,482900,811635,663209,151605,985672,887840,73583,140185,663611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]