SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147413 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147413 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477417,1020356,819883,213365,70660,743828,816407,40036,782421,842466,385059,378203,1002808,746797,1044301,918436,166801,229869,236861,993211,652637,904886,117837,308043,889787,658759,635529,294630,355313,739604,82551,960679,641405,909929,469175,313356,420192,851725,406812,460752,557390,484615,361036,765518,861525,304478,712663,896932,312961,1041933,794474,914376,515769,769001,790907,658673,489047,284907,283581,694210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]