SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422159 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422159 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573370,719481,519997,765150,186072,896570,858456,706831,789469,864400,656805,696192,122258,381925,373739,436990,435225,411990,341114,950650,7082,849774,498227,495170,405845,564427,311342,589925,840383,287733,641970,275813,157287,711071,428463,105129,967306,784928,242413,164905,929364,28455,912548,626782,224948,499544,22029,439380,106442,463407,432895,705069,322476,338316,642822,322814,597043,828979,136783,291777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]