SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501621 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501621 [ RunTime:0.002315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286177,57752,742535,795084,1010911,973448,242849,274996,559448,906008,171494,593225,771197,391009,1041999,958896,419670,1031346,56023,773487,585688,273448,232042,721491,733729,255782,983659,786620,307054,153741,960985,994915,389584,205582,554461,438881,1047922,961870,266570,246578,566036,301548,296477,233731,65844,742682,222885,420177,163305,666017,960262,28422,677979,145874,654116,47711,276068,278320,628769,136678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]