SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401181 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401181 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726258,179852,367170,262013,379345,948277,404020,391488,220475,377101,353317,685665,522439,637438,530778,63497,963086,699780,452846,830967,483331,75802,703728,376033,203023,989252,23811,979686,736169,657211,508577,776530,16788,499900,16158,280583,576983,509694,198730,96373,651037,23193,708108,679031,474718,81812,452293,584583,782811,636563,558751,196642,857300,114338,289477,63643,762674,210607,313951,73021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]