SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39201 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39201 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859774,132840,391116,786221,658627,147190,633788,917267,519747,712844,987269,104041,1038452,74045,848243,70240,483138,19330,1040312,555991,678609,604686,485296,631730,688004,524304,190242,152885,461948,658450,646164,295359,901919,459912,694207,44567,575179,663763,424025,725262,497963,458461,205435,57825,748567,941271,864509,934403,34405,354659,27631,227427,1000324,325604,892048,744183,806899,113331,471998,383612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]