SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401279 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401279 [ RunTime:0.003443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79634,420834,118541,661524,1006507,787236,143530,484486,922548,737576,584223,450688,502603,812601,297160,11862,85811,696920,439718,869552,697504,757517,814553,213946,969130,460159,78720,465912,670706,465897,848821,32262,171207,656339,907932,220357,491100,233195,920774,814561,40842,545948,840686,228340,375546,420209,44875,484812,192366,882018,596045,885644,512747,913891,141974,902822,280463,654112,24671,407872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401279 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401279 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]