SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34408 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34408 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101025,539194,35100,279473,781091,270399,591648,528053,648582,543607,946689,161746,834116,951353,12466,185400,76161,685249,956594,972858,863480,136297,330468,428309,282258,859541,721813,666787,233686,122427,932714,698766,783043,282215,977184,475216,398417,227591,43895,1026430,920593,819152,287066,1048404,776143,889117,647928,301800,703019,585755,175951,915560,581975,359985,133842,639608,614609,1022810,970473,218815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]