SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285535 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285535 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20069,873806,890568,883418,70221,391562,479973,781360,893163,66769,694891,917386,269494,838609,762936,778249,828634,1003539,572654,782396,717965,380666,340463,464030,819628,543710,123801,222460,836029,476401,870675,362548,236871,932923,569628,301116,199260,790428,418675,763322,77115,366970,875951,700758,494210,1004727,388060,909835,829300,289025,390764,742780,896192,220868,392420,755936,901146,465480,745749,248707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]