SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482056 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482056 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186938,914423,569021,43088,3556,740381,971370,805000,141629,152191,926678,651637,507764,704296,407918,572109,245119,487252,949801,225328,75775,932059,312943,148845,121347,452332,94523,810674,888838,316197,338718,667805,432800,109031,119443,11012,606437,601659,959025,899346,116475,1020198,998573,584423,226121,234724,55094,314933,791766,782980,873227,502565,626942,77368,544626,143287,282283,463718,412682,242154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]