SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822813 LIMIT 1 [ RunTime:0.002364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822813 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570214,519037,37153,1003731,469003,375744,266290,775750,197988,636704,480823,179042,434531,304999,915601,483634,291387,182713,1033031,444774,911986,664467,423647,458615,1035155,112481,83815,799790,944139,3501,649074,831983,68503,639226,402075,906558,290149,488018,141997,87835,587633,54817,350041,73671,514010,281898,516789,704859,676094,318137,147881,534326,65875,183490,415485,759255,827390,419262,1016507,114471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001401s ]