SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201506 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201506 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250974,287388,959373,226157,1027309,640535,249241,10453,258881,725305,1018987,204711,292373,726333,1004652,136226,280613,777260,466131,683373,666235,805472,732026,781125,219859,402712,175971,1040994,941394,859127,80236,382747,868426,520404,474537,720237,220831,307974,690836,463500,326568,67270,242358,596749,215150,902634,971369,821139,131271,658086,949223,138933,868657,125088,408155,543305,761032,1032876,1023015,696164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000856s ]