SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513329 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513329 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581858,391466,292846,890252,75385,291132,960250,234518,148314,964803,892656,365577,274408,567853,643671,298480,909691,1008067,263883,76409,258391,122972,291188,332291,70717,356833,379546,560383,151101,353047,476701,955044,464222,421374,573967,93648,505189,769160,429380,36199,300846,478799,810474,380666,576490,1026185,823122,910441,100091,220773,1037082,650833,935967,674951,592693,112203,740774,704019,673928,409648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]