SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548804 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548804 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482262,247790,447076,1034275,73148,24223,256600,844106,942088,816031,1013855,57101,237938,557133,882346,169817,901774,320569,178475,824902,190699,71456,135274,744889,10841,73734,278258,703995,219142,429325,573938,91465,484063,537618,206838,106325,53379,507632,674039,635393,342845,334803,647698,27073,18093,59673,406303,795524,35326,840052,162589,1022570,853868,581257,78172,591930,727356,818630,458427,625279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]