SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505360 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505360 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28212,58663,630942,802712,628874,531613,278589,526646,764354,893550,503649,423000,189436,285109,511967,762019,689503,504556,444073,846753,668591,301570,836894,586190,873428,990049,479486,944394,751836,1011402,1038027,338262,962389,75646,767236,224496,1009129,85600,503163,540719,706023,493812,1025096,317280,221550,959389,593309,1012330,78905,504256,861333,38106,516417,940820,513009,910732,956149,937528,246860,813855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]