SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498597 LIMIT 1 [ RunTime:0.001909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498597 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128992,418220,401131,229282,247268,515680,160690,270670,416591,646678,645313,751593,719015,999669,60543,743613,151379,560386,38631,251943,245075,965257,344993,273912,822181,1007027,326750,579491,1006416,109998,64663,302383,362521,695931,124508,777572,220503,849873,720409,830158,141108,445624,857936,667841,341244,360188,806114,867352,442051,611131,955647,169124,290415,986183,987049,850651,721300,39607,379475,730843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]