SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036885 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036885 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524469,977739,341592,231087,318028,1007282,631762,899234,755138,663198,739628,189645,1011833,259915,73907,837946,394760,80291,739340,247748,783980,820338,741866,347311,215081,338908,28738,970662,367402,20569,514179,330025,668341,217643,689528,500020,638254,361217,214317,780464,801111,96544,402947,841769,70720,1040230,128560,1006791,240618,1011004,713813,608920,815192,948070,645072,428221,678885,1033148,185019,619288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]