SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504010 LIMIT 1 [ RunTime:0.001075s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504010 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436530,458209,799872,104984,486259,438613,2917,376135,570693,128669,109771,537269,948909,932043,206569,275595,272105,334498,576334,438243,691056,495072,613401,403198,199676,405597,724610,436576,759886,632804,274397,544311,67206,697210,772073,156659,519227,105533,1025388,899626,255778,16966,434581,126928,84340,759589,825474,568934,564721,432777,799900,422726,731949,888499,159317,898120,691333,343501,812191,466847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001937s ]