SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521180 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521180 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443656,474928,949906,421700,556713,170919,389237,727116,802393,842449,25648,147836,869185,701359,857368,852817,992292,921399,519570,663004,36811,556829,607527,15377,614484,682521,808779,1037048,795830,841251,751101,240257,928060,644660,662715,288890,885003,574078,160385,798301,314194,647486,240119,196236,77557,564648,454729,323379,362592,352612,462701,608758,673555,971597,330313,31203,568140,492828,89637,335926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]