SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386418 LIMIT 1 [ RunTime:0.002097s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386418 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51624,243645,732319,608584,94378,334215,454677,618486,201675,1004596,465832,738248,360668,616447,1033618,561957,611605,504777,752337,668406,486015,449033,719442,322166,633246,22310,524867,698166,678397,459526,964352,391764,702215,937118,446659,687834,1033462,865673,599273,541397,80668,252601,913263,386309,499730,532966,903946,160778,802870,583840,265875,685431,80093,15698,444048,795423,255129,564925,382238,776432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]