SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397945 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397945 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146406,402186,443160,252294,691577,772813,1014717,168411,998925,865904,114822,556354,175543,908706,1033369,82998,102580,648406,956726,158529,688643,930754,208244,515633,767307,974686,779831,1032874,166601,368467,987513,942734,620310,528274,438078,813547,272541,914001,394084,981751,594687,788453,670999,215717,359503,730980,1017955,464116,644535,131278,1011240,447437,910928,567931,694618,313104,600024,703860,887591,157531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]