SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521522 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521522 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71222,328388,687626,96640,412486,941532,1002447,455931,993307,732709,904090,962508,27362,965894,1007760,44939,197717,1027547,121265,667508,710728,34141,159418,586811,968404,851552,152968,15097,888586,885463,613928,222402,897037,50169,378106,3790,594223,544628,61584,635249,166550,609266,667319,1011765,92775,575799,468803,569198,949845,318241,521198,984529,197456,84872,275038,308258,941508,132559,737981,38871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]