SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710401 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710401 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753119,760407,384623,750598,73547,390779,124573,366129,586279,234309,349432,936999,302661,592212,295872,733426,124685,172998,7313,281205,552821,150951,612386,314733,837436,734009,505530,775970,467528,219321,1031446,717904,917865,57111,940159,644032,405887,187949,384420,697163,872051,341943,291646,621605,15950,229810,746138,655977,771591,427472,73531,253895,887147,552157,563858,605039,136768,588929,408978,733885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]