SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107133 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107133 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351091,1048004,519115,1043142,62238,724341,1042284,486041,1027914,397801,333480,418047,815895,54485,983045,790122,28319,592086,119097,375923,205189,725269,795952,178501,720354,724678,648606,105043,60509,845818,651180,801028,978471,452785,618530,735520,66538,786566,983841,107423,813704,655724,739056,809445,556850,982520,684999,902747,140756,989731,259960,401525,221499,610889,963877,477573,246224,258223,442278,575035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]