SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 653218 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 653218 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710451,876758,1017951,347344,811271,376047,231719,793848,62621,122498,251114,207163,766395,406293,566640,614096,1037393,1042345,442147,585223,978531,788096,380851,728075,58590,479357,402390,546031,533228,1536,261553,241363,77581,730892,817875,726174,309397,619266,911719,321130,697781,293586,529108,178194,518497,367572,579976,441321,451509,692563,1016464,758839,805191,242576,442650,898332,661150,549796,200619,434618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 653218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 653218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]