SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91091 LIMIT 1 [ RunTime:0.001540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91091 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833698,474706,812831,930711,54928,499551,202018,509843,558827,890976,805965,275411,946478,549049,749787,699013,846889,27277,268638,415777,314517,207386,783231,859667,757302,796655,635121,544948,842876,127319,678131,930479,486282,493135,981260,117818,129153,16881,736481,32764,209803,504775,105543,248585,753265,320816,93887,1027712,847410,713736,478470,783105,167294,37838,360252,575821,75002,181680,489779,306545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]