SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513218 LIMIT 1 [ RunTime:0.003406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513218 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850041,497391,548983,331745,670242,909324,271283,702928,394320,975120,60561,1030470,263130,144851,765420,365818,754802,404890,435125,867034,477197,912560,519788,559627,562687,8529,924263,582948,353322,1035431,465861,546399,247604,490160,240523,135536,657021,447527,338616,344316,452709,597903,502683,751592,190122,535285,214492,523642,151372,907180,764748,355123,60945,264670,1045449,107801,182923,354641,211349,6441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]