SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193409 LIMIT 1 [ RunTime:0.000840s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193409 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904327,96139,879898,120507,134539,484786,356614,623464,450546,718285,522139,332179,234876,60477,432784,68795,409878,228542,808139,373713,345810,913490,327608,406119,499800,924272,411035,320621,147301,187945,332092,631451,418487,669358,667330,414512,684934,556587,1037568,439635,124243,395587,69831,271625,236178,821408,390501,730113,575982,3169,484056,89395,466379,798640,412733,573886,734052,301856,131248,455290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002565s ]