SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022131 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022131 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594383,821483,272147,149120,998943,123229,904421,706956,993067,1037559,896998,814254,681838,255292,417868,21139,549933,679503,623586,87929,904013,573684,606507,973957,200335,346911,47300,861840,716987,483360,587665,254081,606016,875226,72075,938789,480338,720616,311777,646230,522058,672173,293516,239890,659884,46402,125116,66844,437538,989492,1003639,429879,601334,555542,167943,232555,515082,810912,69072,653328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]