SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566227 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566227 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835058,1018446,554651,503911,321512,396507,1017804,761753,624845,882026,580352,186458,775583,483259,499558,240593,680692,571073,590503,985868,605500,701869,293843,100547,902806,885578,872244,508163,1044875,506297,437910,377520,609280,987822,974108,305762,957758,604845,194977,461996,742273,902594,722888,732481,975410,554179,982454,42001,597537,660577,143357,674705,430663,1022828,875189,944352,736028,454134,541745,410250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]