SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001901s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524508 LIMIT 1 [ RunTime:0.003794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524508 [ RunTime:0.003796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672567,772984,715692,453959,581123,559190,28265,742936,651692,698587,99303,185092,889508,657519,838625,679280,28385,288903,381123,663718,587451,545009,654717,742991,28304,1001980,215811,819149,1018950,997272,1045105,636054,274002,52596,998342,530782,53003,535677,133991,565076,994616,54791,669130,401164,836576,767544,942650,224981,628584,288849,176709,811155,184249,677127,560695,584769,725416,60323,442930,629351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]