SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435203 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435203 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290651,857146,502288,920317,40510,255163,562646,191312,201534,607436,875892,649827,222486,184314,919216,485676,209939,819992,124657,920013,105837,641507,621643,776204,707831,141135,766579,125985,448191,347451,278309,998236,103119,146698,28869,297459,1001271,590442,20329,432306,8655,140803,40518,169573,1023953,184028,115378,902480,357468,752894,303319,486275,407215,112429,403130,956185,176175,8204,996557,889863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]