SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408711 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408711 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329121,516196,578971,433212,751020,143598,464460,673245,66684,563387,1019691,737409,400307,143839,102906,525299,56842,963983,474332,819566,552411,87820,534055,750448,507555,390794,586030,731655,865561,169946,410328,853,74602,550293,422352,908399,468002,560718,290144,950856,345812,718467,631063,539085,676172,444005,74469,413140,576554,233656,166094,574880,962681,768533,1005859,342009,1040019,558113,723548,320729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]