SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801999 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801999 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104915,592108,759145,1013576,487197,252791,908531,980375,201880,841265,257330,118648,807237,164644,296259,944177,1034317,339165,409561,470670,438271,720978,561836,436930,1042883,840612,582555,190356,1001248,613660,401937,242439,1043446,150709,179994,563524,553141,413463,301440,377074,235577,393842,689364,1017501,86339,116520,148418,533834,546812,174677,250632,988688,873057,790968,5717,695854,849500,639084,172905,923697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]