SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446510 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446510 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274592,770161,497134,209448,248358,726239,348761,763841,494087,857968,525774,141491,637746,785575,470328,1030773,13887,119209,676786,457101,410488,869070,758708,436613,818840,43775,186706,583173,138187,1005757,556383,571871,212444,709412,669614,1041145,758092,231927,494685,990720,352319,1013007,688026,803235,315634,459668,37716,246637,274895,558939,299861,698546,712301,728751,108736,907814,178472,70904,793614,790882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]